home *** CD-ROM | disk | FTP | other *** search
/ Visual Basic Controls / Visual Basic Controls.iso / vbcontrol / ewebedit / update.asp < prev    next >
Encoding:
Text File  |  1999-06-16  |  1.5 KB  |  47 lines
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  2. <!--- Updates the content to the Database Record = 2 Also displays the results. --->
  3. <html>
  4. <head>
  5. <!--#include file="adovbs.inc"-->
  6. <TITLE>update Database with contents from editor</TITLE>
  7. <!--- TextHTMLHField is the hidden field posted to this page, it contains the editor html content --->
  8. <% 
  9.     temp=Request.Form("TextHTMLHField")
  10.     temp=Replace(temp, "'", "''")
  11.  
  12.     set conn=server.createobject("adodb.connection")
  13.     conn.open "DSN=editor"
  14.  
  15.     SQLstmt = "UPDATE WYSIWYG SET edit_html = '" & temp & "' WHERE edit_id = 2"
  16.     Set RS = Conn.Execute(SQLStmt)
  17.  
  18.     set rstemp=nothing
  19.     Conn.Close
  20.     set conntemp=nothing
  21. %>
  22.  
  23. </head>
  24.  
  25. <body bgcolor="white">
  26.     <table width="625" cellpadding="0" cellspacing="0" border="0">
  27.         <tr>
  28.             <td width="113" height="35" valign="TOP" bgcolor="#639C63"><a href="http://www.ektron.com"><img src="EKlogo.gif" width=113 height=35 alt="" border=0></a></td>
  29.             <td width="505" align="CENTER" valign="BOTTOM" bgcolor="#639C63"></td>
  30.         </tr>
  31.         <tr>
  32.             <td align="CENTER" valign="TOP" bgcolor="#639C63"><img src="http://www.ektron.com/images/space.gif" width=1 height=300 alt="" border="0"></td>
  33.             <td align="center" valign="top">
  34.                 <table>
  35.                     <tr>
  36.                         <td></td>
  37.                     </tr>        
  38.                     <tr>
  39.                         <td><font face="verdana, arial, helvetica" size="3">The Database has been updated Click <a href="index.asp">here</a> to return to main page</font></td>
  40.                     </tr>        
  41.                 </table>
  42.             </td>
  43.         </tr>
  44.     </table>
  45. </body>
  46. </html>
  47.